package com.mskj.zxmy.mapper;// MaterialInfoMapper.java
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;

@Mapper
public interface MaterialInfoMapper {

    List<String> selectProductNumbersByFilter(
        @Param("productName") String productName,
        @Param("productSpecifications") String productSpecifications,
        @Param("materialCategory") String materialCategory,
        @Param("brand") String brand
    );

    List<String> selectProductNumbersByFilterOut(
        @Param("productName") String productName,
        @Param("productSpecifications") String productSpecifications,
        @Param("materialCategory") String materialCategory,
        @Param("brand") String brand
    );

    List<String> selectProductNumbersByFilterStock(String productName, String productSpecifications, String materialCategory, String brand);
}